<?php

//连接到数据库
require 'connect.php';
$id=  isset($_GET['id'])?$_GET['id']:0;
//获取信息
if (empty($_POST))//判断$_POST是否有数据 
    {
        $sql="SELECT * FROM tb_emp where e_id=$id";
        $result=$dd->query($sql);
        $row=$result->fetch_assoc();
        require 'edit_html.php';
    }
else
    {
            $e_name=$_POST['e_name'];
            $e_dept=$_POST['bumen'];
            $e_img=$_POST['e_img'];
            $date_of_birth=$_POST['date_of_birth'];
            $date_of_entry=$_POST['date_of_entry'];
            $sql="insert into tb_emp (e_name,e_dept,e_img,date_of_birth,date_of_entry) values('$e_name','$e_dept','$e_img','$date_of_birth','$date_of_entry')";
            $result=$dd->query($sql); //执行sql语句 将结果赋给$result

//判断是否添加成功
            if($result)
            {
                echo "<script language='javascript'type='text/javascript'>";
                echo   " alert('添加成功');";
                echo   " window.location.href='index.php';";
                echo    "</script>";
            }
            else
            {
                echo "<script language='javascript'type='text/javascript'>";
                echo   " alert('添加失败');";
                echo   " window.location.href='index.php';";
                echo    "</script>";
            }
   }